Internet Assistant for Microsoft® Excel

Simply click on the links below to jump to a particular topic:

1. Introduction
2. System Requirements
3. Download and Installation Instructions
4. Step by Step Instructions on Usage
5. Feedback
6. Updates

Introduction

This no-charge add-in wizard will provide Microsoft Excel users with the ability to create and distribute Microsoft Excel documents on-line for viewing with any popular browsers. The Internet Assistant for Microsoft Excel for Windows, by pressing a series of buttons, will assist users in converting their spreadsheet data to HTML format either as a separate or into an existing document.

With the increased demand for complex electronic document sharing via the Internet or your organizations' Intranets, it has become critical that the small business user be able to easily create, edit and convert files for these two important mediums. With this add-in, users will be able to leverage their existing Microsoft Excel spreadsheet data.

Go Back

System Requirements

The Internet Assistant for Microsoft Excel can be used with the following Microsoft Excel versions:

• 7.0 - Microsoft Windows® 95
• 5.0 - 32-bit Microsoft Windows (Microsoft Windows® NT 3.x)
• 5.0 - 16-bit Microsoft Windows (Microsoft Windows® 3.x)
• 5.0 - Apple® Macintosh® and Apple Power® Macintosh

Go Back

Download and Installation Instructions

The Internet Assistant for Microsoft Excel add-in file, HTML.XLA, should reside in the Microsoft Excel Library directory. The path to this directory is different depending on which version of Microsoft Excel you are running.

For standalone Excel 5.0, you will find the Library directory directly under the EXCEL directory (for example, C:\EXCEL\LIBRARY on a Microsoft Windows system and My Computer:Excel:Library on an Apple Macintosh system).

For MS Office and Excel 7.0, you will find the Library directory under the MSOFFICE and EXCEL directories (for example, C:\MSOFFICE\EXCEL\LIBRARY).

Download the Internet Assistant for Microsoft Excel

Installation Instructions

1. Copy HTML.XLA to the Microsoft Excel Library Directory (See above for platform specific pathname). 2. Run Microsoft Excel

3. On the Tools menu, select Add-Ins.

4. Check the Internet Assistant Wizard checkbox. 5. Click OK.

Go Back

Step by Step Instructions on Usage

After installing the HTML Add-In into the proper directory and selecting it from the Add-Ins option, 'Internet Assistant Wizard' appears as one of Microsoft Excel menu options under 'Tools'. Now, you're ready to start creating an HTML document.

1. Under the Tools menu choose Internet Assistant Wizard. 2. Select the cells containing the table you want to convert. Click Next.

3. Select whether to create a separate HTML file or to insert the table in an existing template. Click Next. 4. If you chose to copy the table into an existing HTML document, then Make sure that the string, ##Table##, exists in the HTML document where you want the table to reside. Go to Step 6 in this tutorial.

5. Enter the header and footer information that you want to have appear on the HTML document. Click Next.

6. Select whether to convert just the data or to retain rich color, font, and text formatting. Click Next. 7. Enter the pathname for the file that you want to save. 8. Click Finish to generate an HTML document with spreadsheet data.

Congratulations!! You created / edited an HTML document using the easy to use Internet Assistant for Microsoft Excel. Now open the HTML document that you just created, with Microsoft Internet Explorer version 2.0, to see rich color and text of your spreadsheet data (See example below).

Product mix with profit margin
			TV set	Stereo	Speaker
		Number to Build->	100	100	100
Part Name	Inventory	No. Used
Chassis	450	200	1	1	0
Picture Tube	250	100	1	0	0
Speaker Cone	800	500	2	2	1
Power Supply	450	200	1	1	0
Electronics	600	400	2	1	1
			Profits:
		By Product	$4,732	$3,155	$2,208
		Total	$10,095

Go Back

Updates

The Microsoft Excel team plans to update this and other wizards on a regular basis. We will make them available in the following ways:

• The Microsoft Internet site, http://www.microsoft.com/msexcel
• Compuserve Information Service, Go MSEXCEL
• Microsoft TechNet CD

Go Back

© 1995 Microsoft Corporation. All rights reserved. Microsoft, Microsoft Excel, Microsoft Office, Windows, Windows NT, Windows 95, Microsoft Network, and Microsoft TechNet are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

® Apple, Macintosh, Power Macintosh are registered trademarks of Apple Computer, Inc.

Microsoft Excel Home Page